Home Insurance Data Report

Dataset statistics

Number of variables	67
Number of observations	2561
Missing cells	49703
Missing cells (%)	29.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.3 MiB
Average record size in memory	536.0 B

Variable types

Numeric	18
Categorical	18
Boolean	30
Unsupported	1

Warnings

`HP1_ADDON_PRE_REN` has constant value "False"	Constant
`QUOTE_DATE` has a high cardinality: 495 distinct values	High cardinality
`COVER_START` has a high cardinality: 854 distinct values	High cardinality
`P1_DOB` has a high cardinality: 1768 distinct values	High cardinality
`MTA_DATE` has a high cardinality: 205 distinct values	High cardinality
`Police` has a high cardinality: 2561 distinct values	High cardinality
`df_index` is highly correlated with `i`	High correlation
`MTA_FAP` is highly correlated with `LAST_ANN_PREM_GROSS`	High correlation
`LAST_ANN_PREM_GROSS` is highly correlated with `MTA_FAP`	High correlation
`i` is highly correlated with `df_index`	High correlation
`QUOTE_DATE` has 1282 (50.1%) missing values	Missing
`COVER_START` has 666 (26.0%) missing values	Missing
`CLAIM3YEARS` has 659 (25.7%) missing values	Missing
`P1_EMP_STATUS` has 666 (26.0%) missing values	Missing
`P1_PT_EMP_STATUS` has 2545 (99.4%) missing values	Missing
`BUS_USE` has 666 (26.0%) missing values	Missing
`CLERICAL` has 2529 (98.8%) missing values	Missing
`AD_BUILDINGS` has 666 (26.0%) missing values	Missing
`RISK_RATED_AREA_B` has 1158 (45.2%) missing values	Missing
`NCD_GRANTED_YEARS_B` has 666 (26.0%) missing values	Missing
`AD_CONTENTS` has 666 (26.0%) missing values	Missing
`RISK_RATED_AREA_C` has 749 (29.2%) missing values	Missing
`SUM_INSURED_CONTENTS` has 666 (26.0%) missing values	Missing
`NCD_GRANTED_YEARS_C` has 666 (26.0%) missing values	Missing
`CONTENTS_COVER` has 666 (26.0%) missing values	Missing
`BUILDINGS_COVER` has 666 (26.0%) missing values	Missing
`SPEC_SUM_INSURED` has 666 (26.0%) missing values	Missing
`SPEC_ITEM_PREM` has 666 (26.0%) missing values	Missing
`UNSPEC_HRP_PREM` has 666 (26.0%) missing values	Missing
`P1_DOB` has 666 (26.0%) missing values	Missing
`P1_MAR_STATUS` has 666 (26.0%) missing values	Missing
`P1_POLICY_REFUSED` has 666 (26.0%) missing values	Missing
`P1_SEX` has 666 (26.0%) missing values	Missing
`APPR_ALARM` has 666 (26.0%) missing values	Missing
`APPR_LOCKS` has 666 (26.0%) missing values	Missing
`BEDROOMS` has 666 (26.0%) missing values	Missing
`WALL_CONSTRUCTION` has 666 (26.0%) missing values	Missing
`FLOODING` has 666 (26.0%) missing values	Missing
`NEIGH_WATCH` has 666 (26.0%) missing values	Missing
`OCC_STATUS` has 666 (26.0%) missing values	Missing
`OWNERSHIP_TYPE` has 666 (26.0%) missing values	Missing
`PROP_TYPE` has 666 (26.0%) missing values	Missing
`SAFE_INSTALLED` has 666 (26.0%) missing values	Missing
`SEC_DISC_REQ` has 666 (26.0%) missing values	Missing
`SUBSIDENCE` has 666 (26.0%) missing values	Missing
`YEARBUILT` has 666 (26.0%) missing values	Missing
`CAMPAIGN_DESC` has 2561 (100.0%) missing values	Missing
`PAYMENT_METHOD` has 666 (26.0%) missing values	Missing
`LEGAL_ADDON_PRE_REN` has 666 (26.0%) missing values	Missing
`LEGAL_ADDON_POST_REN` has 666 (26.0%) missing values	Missing
`HOME_EM_ADDON_PRE_REN` has 666 (26.0%) missing values	Missing
`HOME_EM_ADDON_POST_REN` has 666 (26.0%) missing values	Missing
`GARDEN_ADDON_PRE_REN` has 666 (26.0%) missing values	Missing
`GARDEN_ADDON_POST_REN` has 666 (26.0%) missing values	Missing
`KEYCARE_ADDON_PRE_REN` has 666 (26.0%) missing values	Missing
`KEYCARE_ADDON_POST_REN` has 666 (26.0%) missing values	Missing
`HP1_ADDON_PRE_REN` has 666 (26.0%) missing values	Missing
`HP1_ADDON_POST_REN` has 666 (26.0%) missing values	Missing
`HP2_ADDON_PRE_REN` has 666 (26.0%) missing values	Missing
`HP2_ADDON_POST_REN` has 666 (26.0%) missing values	Missing
`HP3_ADDON_PRE_REN` has 666 (26.0%) missing values	Missing
`HP3_ADDON_POST_REN` has 666 (26.0%) missing values	Missing
`MTA_FLAG` has 659 (25.7%) missing values	Missing
`MTA_FAP` has 1982 (77.4%) missing values	Missing
`MTA_APRP` has 1982 (77.4%) missing values	Missing
`MTA_DATE` has 2302 (89.9%) missing values	Missing
`LAST_ANN_PREM_GROSS` has 659 (25.7%) missing values	Missing
`POL_STATUS` has 666 (26.0%) missing values	Missing
`WALL_CONSTRUCTION` is highly skewed (γ1 = -22.50128421)	Skewed
`P1_DOB` is uniformly distributed	Uniform
`MTA_DATE` is uniformly distributed	Uniform
`Police` is uniformly distributed	Uniform
`df_index` has unique values	Unique
`i` has unique values	Unique
`Police` has unique values	Unique
`CAMPAIGN_DESC` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`RISK_RATED_AREA_B` has 163 (6.4%) zeros	Zeros
`NCD_GRANTED_YEARS_B` has 449 (17.5%) zeros	Zeros
`RISK_RATED_AREA_C` has 166 (6.5%) zeros	Zeros
`SUM_INSURED_CONTENTS` has 83 (3.2%) zeros	Zeros
`NCD_GRANTED_YEARS_C` has 96 (3.7%) zeros	Zeros
`SPEC_SUM_INSURED` has 1636 (63.9%) zeros	Zeros
`SPEC_ITEM_PREM` has 1637 (63.9%) zeros	Zeros
`UNSPEC_HRP_PREM` has 1390 (54.3%) zeros	Zeros
`MTA_APRP` has 274 (10.7%) zeros	Zeros

Reproduction

Analysis started	2021-01-25 20:52:38.385311
Analysis finished	2021-01-25 20:53:49.653387
Duration	1 minute and 11.27 seconds
Software version	pandas-profiling v2.10.0
Download configuration	config.yaml

df_index
Real number (ℝ_≥0)

HIGH CORRELATION
UNIQUE

Distinct	2561
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	129829.3581
Minimum	32
Maximum	256112
Zeros	0
Zeros (%)	0.0%
Memory size	20.1 KiB

Quantile statistics

Minimum	32
5-th percentile	12462
Q1	66921
median	129825
Q3	194809
95-th percentile	243393
Maximum	256112
Range	256080
Interquartile range (IQR)	127888

Descriptive statistics

Standard deviation	74214.84674
Coefficient of variation (CV)	0.5716337803
Kurtosis	-1.19492662
Mean	129829.3581
Median Absolute Deviation (MAD)	63944
Skewness	-0.0282409952
Sum	332492986
Variance	5507843477
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
253952	1	< 0.1%
239598	1	< 0.1%
53913	1	< 0.1%
185054	1	< 0.1%
68252	1	< 0.1%
27855	1	< 0.1%
82591	1	< 0.1%
105381	1	< 0.1%
144033	1	< 0.1%
88738	1	< 0.1%
Other values (2551)	2551	99.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
32	1	< 0.1%
139	1	< 0.1%
199	1	< 0.1%
259	1	< 0.1%
280	1	< 0.1%

Value	Count	Frequency (%)
256112	1	< 0.1%
256091	1	< 0.1%
255983	1	< 0.1%
255961	1	< 0.1%
255891	1	< 0.1%

QUOTE_DATE
Categorical

HIGH CARDINALITY
MISSING

Distinct	495
Distinct (%)	38.7%
Missing	1282
Missing (%)	50.1%
Memory size	20.1 KiB

11/21/2011	10
1/14/2010	9
1/11/2011	9
1/18/2011	9
12/5/2011	8
Other values (490)	1234

Length

Max length	10
Median length	9
Mean length	9.248631744
Min length	8

Characters and Unicode

Total characters	11829
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	187 ?
Unique (%)	14.6%

Sample

1st row	11/5/2011
2nd row	1/6/2010
3rd row	1/11/2011
4th row	1/20/2009
5th row	11/28/2007

Value	Count	Frequency (%)
11/21/2011	10	0.4%
1/14/2010	9	0.4%
1/11/2011	9	0.4%
1/18/2011	9	0.4%
12/5/2011	8	0.3%
1/20/2011	8	0.3%
11/18/2009	8	0.3%
1/10/2011	8	0.3%
12/16/2010	8	0.3%
1/5/2011	7	0.3%
Other values (485)	1195	46.7%
(Missing)	1282	50.1%

Histogram of lengths of the category

Value	Count	Frequency (%)
11/21/2011	10	0.8%
1/11/2011	9	0.7%
1/14/2010	9	0.7%
1/18/2011	9	0.7%
1/20/2011	8	0.6%
12/5/2011	8	0.6%
1/10/2011	8	0.6%
11/18/2009	8	0.6%
12/16/2010	8	0.6%
11/10/2011	7	0.5%
Other values (485)	1195	93.4%

Most occurring characters

Value	Count	Frequency (%)
1	3242	27.4%
/	2558	21.6%
2	2364	20.0%
0	2244	19.0%
9	328	2.8%
8	289	2.4%
3	212	1.8%
7	198	1.7%
5	143	1.2%
6	128	1.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	9271	78.4%
Other Punctuation	2558	21.6%

Most frequent character per category

Value	Count	Frequency (%)
1	3242	35.0%
2	2364	25.5%
0	2244	24.2%
9	328	3.5%
8	289	3.1%
3	212	2.3%
7	198	2.1%
5	143	1.5%
6	128	1.4%
4	123	1.3%

Value	Count	Frequency (%)
/	2558	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	11829	100.0%

Most frequent character per script

Value	Count	Frequency (%)
1	3242	27.4%
/	2558	21.6%
2	2364	20.0%
0	2244	19.0%
9	328	2.8%
8	289	2.4%
3	212	1.8%
7	198	1.7%
5	143	1.2%
6	128	1.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	11829	100.0%

Most frequent character per block

Value	Count	Frequency (%)
1	3242	27.4%
/	2558	21.6%
2	2364	20.0%
0	2244	19.0%
9	328	2.8%
8	289	2.4%
3	212	1.8%
7	198	1.7%
5	143	1.2%
6	128	1.1%

COVER_START
Categorical

HIGH CARDINALITY
MISSING

Distinct	854
Distinct (%)	45.1%
Missing	666
Missing (%)	26.0%
Memory size	20.1 KiB

01/03/2011	36
01/02/2011	34
01/03/2010	28
01/01/2011	27
01/12/2010	24
Other values (849)	1746

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	18950
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	452 ?
Unique (%)	23.9%

Sample

1st row	10/01/2010
2nd row	15/01/2011
3rd row	09/11/1999
4th row	12/11/2009
5th row	22/12/2006

Value	Count	Frequency (%)
01/03/2011	36	1.4%
01/02/2011	34	1.3%
01/03/2010	28	1.1%
01/01/2011	27	1.1%
01/12/2010	24	0.9%
01/02/2010	18	0.7%
01/12/2009	15	0.6%
01/01/2010	14	0.5%
28/02/2011	12	0.5%
01/02/2009	12	0.5%
Other values (844)	1675	65.4%
(Missing)	666	26.0%

Histogram of lengths of the category

Value	Count	Frequency (%)
01/03/2011	36	1.9%
01/02/2011	34	1.8%
01/03/2010	28	1.5%
01/01/2011	27	1.4%
01/12/2010	24	1.3%
01/02/2010	18	0.9%
01/12/2009	15	0.8%
01/01/2010	14	0.7%
01/02/2009	12	0.6%
28/02/2011	12	0.6%
Other values (844)	1675	88.4%

Most occurring characters

Value	Count	Frequency (%)
0	5413	28.6%
1	3837	20.2%
/	3790	20.0%
2	3331	17.6%
9	593	3.1%
3	483	2.5%
5	358	1.9%
8	341	1.8%
7	281	1.5%
6	271	1.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	15160	80.0%
Other Punctuation	3790	20.0%

Most frequent character per category

Value	Count	Frequency (%)
0	5413	35.7%
1	3837	25.3%
2	3331	22.0%
9	593	3.9%
3	483	3.2%
5	358	2.4%
8	341	2.2%
7	281	1.9%
6	271	1.8%
4	252	1.7%

Value	Count	Frequency (%)
/	3790	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	18950	100.0%

Most frequent character per script

Value	Count	Frequency (%)
0	5413	28.6%
1	3837	20.2%
/	3790	20.0%
2	3331	17.6%
9	593	3.1%
3	483	2.5%
5	358	1.9%
8	341	1.8%
7	281	1.5%
6	271	1.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	18950	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	5413	28.6%
1	3837	20.2%
/	3790	20.0%
2	3331	17.6%
9	593	3.1%
3	483	2.5%
5	358	1.9%
8	341	1.8%
7	281	1.5%
6	271	1.4%

CLAIM3YEARS
Boolean

MISSING

Distinct	2
Distinct (%)	0.1%
Missing	659
Missing (%)	25.7%
Memory size	5.1 KiB

False	1693
True	209
(Missing)	659

Common Values
Chart

Value	Count	Frequency (%)
False	1693	66.1%
True	209	8.2%
(Missing)	659	25.7%

P1_EMP_STATUS
Categorical

MISSING

Distinct	7
Distinct (%)	0.4%
Missing	666
Missing (%)	26.0%
Memory size	20.1 KiB

R	1445
E	391
S	32
H	11
N	7
Other values (2)	9

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	1895
Distinct characters	7
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	R
2nd row	R
3rd row	R
4th row	E
5th row	R

Value	Count	Frequency (%)
R	1445	56.4%
E	391	15.3%
S	32	1.2%
H	11	0.4%
N	7	0.3%
U	6	0.2%
V	3	0.1%
(Missing)	666	26.0%

Histogram of lengths of the category

Value	Count	Frequency (%)
r	1445	76.3%
e	391	20.6%
s	32	1.7%
h	11	0.6%
n	7	0.4%
u	6	0.3%
v	3	0.2%

Most occurring characters

Value	Count	Frequency (%)
R	1445	76.3%
E	391	20.6%
S	32	1.7%
H	11	0.6%
N	7	0.4%
U	6	0.3%
V	3	0.2%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	1895	100.0%

Most frequent character per category

Value	Count	Frequency (%)
R	1445	76.3%
E	391	20.6%
S	32	1.7%
H	11	0.6%
N	7	0.4%
U	6	0.3%
V	3	0.2%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1895	100.0%

Most frequent character per script

Value	Count	Frequency (%)
R	1445	76.3%
E	391	20.6%
S	32	1.7%
H	11	0.6%
N	7	0.4%
U	6	0.3%
V	3	0.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1895	100.0%

Most frequent character per block

Value	Count	Frequency (%)
R	1445	76.3%
E	391	20.6%
S	32	1.7%
H	11	0.6%
N	7	0.4%
U	6	0.3%
V	3	0.2%

P1_PT_EMP_STATUS
Categorical

MISSING

Distinct	3
Distinct (%)	18.8%
Missing	2545
Missing (%)	99.4%
Memory size	20.1 KiB

E	10
V	4
R	2

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	16
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	E
2nd row	E
3rd row	V
4th row	R
5th row	E

Value	Count	Frequency (%)
E	10	0.4%
V	4	0.2%
R	2	0.1%
(Missing)	2545	99.4%

Histogram of lengths of the category

Value	Count	Frequency (%)
e	10	62.5%
v	4	25.0%
r	2	12.5%

Most occurring characters

Value	Count	Frequency (%)
E	10	62.5%
V	4	25.0%
R	2	12.5%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	16	100.0%

Most frequent character per category

Value	Count	Frequency (%)
E	10	62.5%
V	4	25.0%
R	2	12.5%

Most occurring scripts

Value	Count	Frequency (%)
Latin	16	100.0%

Most frequent character per script

Value	Count	Frequency (%)
E	10	62.5%
V	4	25.0%
R	2	12.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	16	100.0%

Most frequent character per block

Value	Count	Frequency (%)
E	10	62.5%
V	4	25.0%
R	2	12.5%

BUS_USE
Boolean

MISSING

Distinct	2
Distinct (%)	0.1%
Missing	666
Missing (%)	26.0%
Memory size	5.1 KiB

False	1863
True	32
(Missing)	666

Common Values
Chart

Value	Count	Frequency (%)
False	1863	72.7%
True	32	1.2%
(Missing)	666	26.0%

CLERICAL
Boolean

MISSING

Distinct	2
Distinct (%)	6.2%
Missing	2529
Missing (%)	98.8%
Memory size	5.1 KiB

True	27
False	5
(Missing)	2529

Common Values
Chart

Value	Count	Frequency (%)
True	27	1.1%
False	5	0.2%
(Missing)	2529	98.8%

AD_BUILDINGS
Boolean

MISSING

Distinct	2
Distinct (%)	0.1%
Missing	666
Missing (%)	26.0%
Memory size	5.1 KiB

True	1464
False	431
(Missing)	666

Common Values
Chart

Value	Count	Frequency (%)
True	1464	57.2%
False	431	16.8%
(Missing)	666	26.0%

RISK_RATED_AREA_B
Real number (ℝ_≥0)

MISSING
ZEROS

Distinct	44
Distinct (%)	3.1%
Missing	1158
Missing (%)	45.2%
Infinite	0
Infinite (%)	0.0%

Mean	10.0634355
Minimum	0
Maximum	97
Zeros	163
Zeros (%)	6.4%
Memory size	20.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	3
median	9
Q3	14
95-th percentile	25
Maximum	97
Range	97
Interquartile range (IQR)	11

Descriptive statistics

Standard deviation	8.988634218
Coefficient of variation (CV)	0.89319738
Kurtosis	13.37963023
Mean	10.0634355
Median Absolute Deviation (MAD)	6
Skewness	2.277568752
Sum	14119
Variance	80.79554511
Monotocity	Not monotonic

Histogram with fixed size bins (bins=44)

Value	Count	Frequency (%)
0	163	6.4%
3	95	3.7%
10	90	3.5%
8	88	3.4%
1	83	3.2%
7	78	3.0%
12	71	2.8%
13	70	2.7%
5	59	2.3%
11	57	2.2%
Other values (34)	549	21.4%
(Missing)	1158	45.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	163	6.4%
1	83	3.2%
2	34	1.3%
3	95	3.7%
4	45	1.8%

Value	Count	Frequency (%)
97	1	< 0.1%
96	1	< 0.1%
47	6	0.2%
46	5	0.2%
42	1	< 0.1%

SUM_INSURED_BUILDINGS
Categorical

Distinct	3
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	20.1 KiB

1000000.0	1462
nan	666
0.0	433

Length

Max length	9
Median length	9
Mean length	6.425224522
Min length	3

Characters and Unicode

Total characters	16455
Distinct characters	5
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	nan
2nd row	1000000.0
3rd row	1000000.0
4th row	0.0
5th row	1000000.0

Value	Count	Frequency (%)
1000000.0	1462	57.1%
nan	666	26.0%
0.0	433	16.9%

Histogram of lengths of the category

Value	Count	Frequency (%)
1000000.0	1462	57.1%
nan	666	26.0%
0.0	433	16.9%

Most occurring characters

Value	Count	Frequency (%)
0	11100	67.5%
.	1895	11.5%
1	1462	8.9%
n	1332	8.1%
a	666	4.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	12562	76.3%
Lowercase Letter	1998	12.1%
Other Punctuation	1895	11.5%

Most frequent character per category

Value	Count	Frequency (%)
n	1332	66.7%
a	666	33.3%

Value	Count	Frequency (%)
0	11100	88.4%
1	1462	11.6%

Value	Count	Frequency (%)
.	1895	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	14457	87.9%
Latin	1998	12.1%

Most frequent character per script

Value	Count	Frequency (%)
0	11100	76.8%
.	1895	13.1%
1	1462	10.1%

Value	Count	Frequency (%)
n	1332	66.7%
a	666	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	16455	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	11100	67.5%
.	1895	11.5%
1	1462	8.9%
n	1332	8.1%
a	666	4.0%

NCD_GRANTED_YEARS_B
Real number (ℝ_≥0)

MISSING
ZEROS

Distinct	10
Distinct (%)	0.5%
Missing	666
Missing (%)	26.0%
Infinite	0
Infinite (%)	0.0%

Mean	4.449604222
Minimum	0
Maximum	9
Zeros	449
Zeros (%)	17.5%
Memory size	20.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2
median	6
Q3	6
95-th percentile	7
Maximum	9
Range	9
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	2.699186119
Coefficient of variation (CV)	0.6066126299
Kurtosis	-0.950690226
Mean	4.449604222
Median Absolute Deviation (MAD)	1
Skewness	-0.8180380904
Sum	8432
Variance	7.285605704
Monotocity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
6	872	34.0%
0	449	17.5%
7	275	10.7%
5	113	4.4%
3	96	3.7%
4	32	1.2%
9	22	0.9%
2	18	0.7%
1	12	0.5%
8	6	0.2%
(Missing)	666	26.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	449	17.5%
1	12	0.5%
2	18	0.7%
3	96	3.7%
4	32	1.2%

Value	Count	Frequency (%)
9	22	0.9%
8	6	0.2%
7	275	10.7%
6	872	34.0%
5	113	4.4%

AD_CONTENTS
Boolean

MISSING

Distinct	2
Distinct (%)	0.1%
Missing	666
Missing (%)	26.0%
Memory size	5.1 KiB

True	1814
False	81
(Missing)	666

Common Values
Chart

Value	Count	Frequency (%)
True	1814	70.8%
False	81	3.2%
(Missing)	666	26.0%

RISK_RATED_AREA_C
Real number (ℝ_≥0)

MISSING
ZEROS

Distinct	36
Distinct (%)	2.0%
Missing	749
Missing (%)	29.2%
Infinite	0
Infinite (%)	0.0%

Mean	8.918322296
Minimum	0
Maximum	38
Zeros	166
Zeros (%)	6.5%
Memory size	20.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	3
median	7
Q3	13
95-th percentile	23.45
Maximum	38
Range	38
Interquartile range (IQR)	10

Descriptive statistics

Standard deviation	7.598276117
Coefficient of variation (CV)	0.851984921
Kurtosis	1.25416438
Mean	8.918322296
Median Absolute Deviation (MAD)	5
Skewness	1.141251736
Sum	16160
Variance	57.73379994
Monotocity	Not monotonic

Histogram with fixed size bins (bins=36)

Value	Count	Frequency (%)
0	166	6.5%
5	154	6.0%
2	144	5.6%
6	113	4.4%
1	107	4.2%
10	100	3.9%
4	96	3.7%
7	92	3.6%
8	90	3.5%
3	76	3.0%
Other values (26)	674	26.3%
(Missing)	749	29.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	166	6.5%
1	107	4.2%
2	144	5.6%
3	76	3.0%
4	96	3.7%

Value	Count	Frequency (%)
38	3	0.1%
37	17	0.7%
34	2	0.1%
32	1	< 0.1%
31	4	0.2%

SUM_INSURED_CONTENTS
Real number (ℝ_≥0)

MISSING
ZEROS

Distinct	6
Distinct (%)	0.3%
Missing	666
Missing (%)	26.0%
Infinite	0
Infinite (%)	0.0%

Mean	47976.2533
Minimum	0
Maximum	100000
Zeros	83
Zeros (%)	3.2%
Memory size	20.1 KiB

Quantile statistics

Minimum	0
5-th percentile	50000
Q1	50000
median	50000
Q3	50000
95-th percentile	50000
Maximum	100000
Range	100000
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	10522.61434
Coefficient of variation (CV)	0.2193296395
Kurtosis	16.79968313
Mean	47976.2533
Median Absolute Deviation (MAD)	0
Skewness	-3.954208012
Sum	90915000
Variance	110725412.6
Monotocity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
50000	1800	70.3%
0	83	3.2%
75000	7	0.3%
60000	2	0.1%
100000	2	0.1%
70000	1	< 0.1%
(Missing)	666	26.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	83	3.2%
50000	1800	70.3%
60000	2	0.1%
70000	1	< 0.1%
75000	7	0.3%

Value	Count	Frequency (%)
100000	2	0.1%
75000	7	0.3%
70000	1	< 0.1%
60000	2	0.1%
50000	1800	70.3%

NCD_GRANTED_YEARS_C
Real number (ℝ_≥0)

MISSING
ZEROS

Distinct	10
Distinct (%)	0.5%
Missing	666
Missing (%)	26.0%
Infinite	0
Infinite (%)	0.0%

Mean	5.50237467
Minimum	0
Maximum	9
Zeros	96
Zeros (%)	3.7%
Memory size	20.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	6
median	6
Q3	6
95-th percentile	7
Maximum	9
Range	9
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.747186502
Coefficient of variation (CV)	0.3175331755
Kurtosis	3.230840706
Mean	5.50237467
Median Absolute Deviation (MAD)	0
Skewness	-1.836473323
Sum	10427
Variance	3.052660673
Monotocity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
6	1109	43.3%
7	323	12.6%
5	135	5.3%
3	116	4.5%
0	96	3.7%
4	42	1.6%
2	28	1.1%
9	23	0.9%
1	18	0.7%
8	5	0.2%
(Missing)	666	26.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	96	3.7%
1	18	0.7%
2	28	1.1%
3	116	4.5%
4	42	1.6%

Value	Count	Frequency (%)
9	23	0.9%
8	5	0.2%
7	323	12.6%
6	1109	43.3%
5	135	5.3%

CONTENTS_COVER
Boolean

MISSING

Distinct	2
Distinct (%)	0.1%
Missing	666
Missing (%)	26.0%
Memory size	5.1 KiB

True	1464
False	431
(Missing)	666

Common Values
Chart

Value	Count	Frequency (%)
True	1464	57.2%
False	431	16.8%
(Missing)	666	26.0%

BUILDINGS_COVER
Boolean

MISSING

Distinct	2
Distinct (%)	0.1%
Missing	666
Missing (%)	26.0%
Memory size	5.1 KiB

True	1814
False	81
(Missing)	666

Common Values
Chart

Value	Count	Frequency (%)
True	1814	70.8%
False	81	3.2%
(Missing)	666	26.0%

SPEC_SUM_INSURED
Real number (ℝ_≥0)

MISSING
ZEROS

Distinct	111
Distinct (%)	5.9%
Missing	666
Missing (%)	26.0%
Infinite	0
Infinite (%)	0.0%

Mean	361.7889182
Minimum	0
Maximum	18706
Zeros	1636
Zeros (%)	63.9%
Memory size	20.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	2518
Maximum	18706
Range	18706
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1360.932412
Coefficient of variation (CV)	3.76167523
Kurtosis	51.6938458
Mean	361.7889182
Median Absolute Deviation (MAD)	0
Skewness	6.069495542
Sum	685590
Variance	1852137.03
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1636	63.9%
2000	21	0.8%
1000	14	0.5%
3000	11	0.4%
400	9	0.4%
500	9	0.4%
300	8	0.3%
4000	8	0.3%
200	8	0.3%
2500	7	0.3%
Other values (101)	164	6.4%
(Missing)	666	26.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1636	63.9%
100	3	0.1%
119	1	< 0.1%
120	1	< 0.1%
140	1	< 0.1%

Value	Count	Frequency (%)
18706	1	< 0.1%
18700	1	< 0.1%
12190	1	< 0.1%
11500	1	< 0.1%
11000	1	< 0.1%

SPEC_ITEM_PREM
Real number (ℝ_≥0)

MISSING
ZEROS

Distinct	239
Distinct (%)	12.6%
Missing	666
Missing (%)	26.0%
Infinite	0
Infinite (%)	0.0%

Mean	2.813366755
Minimum	0
Maximum	195.41
Zeros	1637
Zeros (%)	63.9%
Memory size	20.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	21.647
Maximum	195.41
Range	195.41
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	10.53073501
Coefficient of variation (CV)	3.743107787
Kurtosis	86.28639715
Mean	2.813366755
Median Absolute Deviation (MAD)	0
Skewness	7.299627143
Sum	5331.33
Variance	110.8963798
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1637	63.9%
15.93	3	0.1%
2.3	3	0.1%
14.33	2	0.1%
1.19	2	0.1%
33.26	2	0.1%
13.16	2	0.1%
12.51	2	0.1%
39.08	2	0.1%
13.36	2	0.1%
Other values (229)	238	9.3%
(Missing)	666	26.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1637	63.9%
0.53	1	< 0.1%
0.71	1	< 0.1%
1.19	2	0.1%
1.31	1	< 0.1%

Value	Count	Frequency (%)
195.41	1	< 0.1%
120.05	1	< 0.1%
119.12	1	< 0.1%
103.3	1	< 0.1%
69.76	1	< 0.1%

UNSPEC_HRP_PREM
Real number (ℝ_≥0)

MISSING
ZEROS

Distinct	186
Distinct (%)	9.8%
Missing	666
Missing (%)	26.0%
Infinite	0
Infinite (%)	0.0%

Mean	5.724654354
Minimum	0
Maximum	68.75
Zeros	1390
Zeros (%)	54.3%
Memory size	20.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	12.69
95-th percentile	27.26
Maximum	68.75
Range	68.75
Interquartile range (IQR)	12.69

Descriptive statistics

Standard deviation	10.3245601
Coefficient of variation (CV)	1.803525499
Kurtosis	2.328141929
Mean	5.724654354
Median Absolute Deviation (MAD)	0
Skewness	1.70054186
Sum	10848.22
Variance	106.5965413
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1390	54.3%
14.86	65	2.5%
16.07	25	1.0%
19.82	17	0.7%
27.26	16	0.6%
17.68	15	0.6%
21.43	15	0.6%
23.21	14	0.5%
23.57	13	0.5%
16.55	13	0.5%
Other values (176)	312	12.2%
(Missing)	666	26.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1390	54.3%
4.34	1	< 0.1%
9.96	4	0.2%
10.58	1	< 0.1%
11.89	6	0.2%

Value	Count	Frequency (%)
68.75	1	< 0.1%
55.76	1	< 0.1%
50.05	1	< 0.1%
47.5	1	< 0.1%
47.29	1	< 0.1%

P1_DOB
Categorical

HIGH CARDINALITY
MISSING
UNIFORM

Distinct	1768
Distinct (%)	93.3%
Missing	666
Missing (%)	26.0%
Memory size	20.1 KiB

12/12/1939	3
02/07/1931	3
25/05/1928	3
14/08/1927	3
01/01/1920	2
Other values (1763)	1881

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	18950
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1645 ?
Unique (%)	86.8%

Sample

1st row	29/10/1943
2nd row	06/07/1943
3rd row	03/05/1936
4th row	16/02/1953
5th row	06/06/1930

Value	Count	Frequency (%)
12/12/1939	3	0.1%
02/07/1931	3	0.1%
25/05/1928	3	0.1%
14/08/1927	3	0.1%
01/01/1920	2	0.1%
06/08/1933	2	0.1%
24/12/1934	2	0.1%
07/06/1943	2	0.1%
22/04/1949	2	0.1%
08/08/1921	2	0.1%
Other values (1758)	1871	73.1%
(Missing)	666	26.0%

Histogram of lengths of the category

Value	Count	Frequency (%)
12/12/1939	3	0.2%
25/05/1928	3	0.2%
02/07/1931	3	0.2%
14/08/1927	3	0.2%
01/08/1939	2	0.1%
29/11/1933	2	0.1%
28/02/1950	2	0.1%
26/05/1934	2	0.1%
04/09/1944	2	0.1%
15/08/1930	2	0.1%
Other values (1758)	1871	98.7%

Most occurring characters

Value	Count	Frequency (%)
/	3790	20.0%
1	3768	19.9%
0	2529	13.3%
9	2374	12.5%
2	1675	8.8%
3	1257	6.6%
4	1096	5.8%
5	781	4.1%
6	588	3.1%
7	580	3.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	15160	80.0%
Other Punctuation	3790	20.0%

Most frequent character per category

Value	Count	Frequency (%)
1	3768	24.9%
0	2529	16.7%
9	2374	15.7%
2	1675	11.0%
3	1257	8.3%
4	1096	7.2%
5	781	5.2%
6	588	3.9%
7	580	3.8%
8	512	3.4%

Value	Count	Frequency (%)
/	3790	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	18950	100.0%

Most frequent character per script

Value	Count	Frequency (%)
/	3790	20.0%
1	3768	19.9%
0	2529	13.3%
9	2374	12.5%
2	1675	8.8%
3	1257	6.6%
4	1096	5.8%
5	781	4.1%
6	588	3.1%
7	580	3.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	18950	100.0%

Most frequent character per block

Value	Count	Frequency (%)
/	3790	20.0%
1	3768	19.9%
0	2529	13.3%
9	2374	12.5%
2	1675	8.8%
3	1257	6.6%
4	1096	5.8%
5	781	4.1%
6	588	3.1%
7	580	3.1%

P1_MAR_STATUS
Categorical

MISSING

Distinct	9
Distinct (%)	0.5%
Missing	666
Missing (%)	26.0%
Memory size	20.1 KiB

M	652
P	457
O	324
W	261
S	106
Other values (4)	95

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	1895
Distinct characters	9
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	D
2nd row	M
3rd row	M
4th row	M
5th row	O

Value	Count	Frequency (%)
M	652	25.5%
P	457	17.8%
O	324	12.7%
W	261	10.2%
S	106	4.1%
D	77	3.0%
A	13	0.5%
C	3	0.1%
B	2	0.1%
(Missing)	666	26.0%

Histogram of lengths of the category

Value	Count	Frequency (%)
m	652	34.4%
p	457	24.1%
o	324	17.1%
w	261	13.8%
s	106	5.6%
d	77	4.1%
a	13	0.7%
c	3	0.2%
b	2	0.1%

Most occurring characters

Value	Count	Frequency (%)
M	652	34.4%
P	457	24.1%
O	324	17.1%
W	261	13.8%
S	106	5.6%
D	77	4.1%
A	13	0.7%
C	3	0.2%
B	2	0.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	1895	100.0%

Most frequent character per category

Value	Count	Frequency (%)
M	652	34.4%
P	457	24.1%
O	324	17.1%
W	261	13.8%
S	106	5.6%
D	77	4.1%
A	13	0.7%
C	3	0.2%
B	2	0.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1895	100.0%

Most frequent character per script

Value	Count	Frequency (%)
M	652	34.4%
P	457	24.1%
O	324	17.1%
W	261	13.8%
S	106	5.6%
D	77	4.1%
A	13	0.7%
C	3	0.2%
B	2	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1895	100.0%

Most frequent character per block

Value	Count	Frequency (%)
M	652	34.4%
P	457	24.1%
O	324	17.1%
W	261	13.8%
S	106	5.6%
D	77	4.1%
A	13	0.7%
C	3	0.2%
B	2	0.1%

P1_POLICY_REFUSED
Boolean

MISSING

Distinct	2
Distinct (%)	0.1%
Missing	666
Missing (%)	26.0%
Memory size	5.1 KiB

False	1894
True	1
(Missing)	666

Common Values
Chart

Value	Count	Frequency (%)
False	1894	74.0%
True	1	< 0.1%
(Missing)	666	26.0%

P1_SEX
Categorical

MISSING

Distinct	2
Distinct (%)	0.1%
Missing	666
Missing (%)	26.0%
Memory size	20.1 KiB

M	1005
F	890

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	1895
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	M
2nd row	F
3rd row	F
4th row	M
5th row	F

Value	Count	Frequency (%)
M	1005	39.2%
F	890	34.8%
(Missing)	666	26.0%

Histogram of lengths of the category

Value	Count	Frequency (%)
m	1005	53.0%
f	890	47.0%

Most occurring characters

Value	Count	Frequency (%)
M	1005	53.0%
F	890	47.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	1895	100.0%

Most frequent character per category

Value	Count	Frequency (%)
M	1005	53.0%
F	890	47.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1895	100.0%

Most frequent character per script

Value	Count	Frequency (%)
M	1005	53.0%
F	890	47.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1895	100.0%

Most frequent character per block

Value	Count	Frequency (%)
M	1005	53.0%
F	890	47.0%

APPR_ALARM
Boolean

MISSING

Distinct	2
Distinct (%)	0.1%
Missing	666
Missing (%)	26.0%
Memory size	5.1 KiB

False	1761
True	134
(Missing)	666

Common Values
Chart

Value	Count	Frequency (%)
False	1761	68.8%
True	134	5.2%
(Missing)	666	26.0%

APPR_LOCKS
Boolean

MISSING

Distinct	2
Distinct (%)	0.1%
Missing	666
Missing (%)	26.0%
Memory size	5.1 KiB

True	1354
False	541
(Missing)	666

Common Values
Chart

Value	Count	Frequency (%)
True	1354	52.9%
False	541	21.1%
(Missing)	666	26.0%

BEDROOMS
Real number (ℝ_≥0)

MISSING

Distinct	6
Distinct (%)	0.3%
Missing	666
Missing (%)	26.0%
Infinite	0
Infinite (%)	0.0%

Mean	2.786807388
Minimum	1
Maximum	6
Zeros	0
Zeros (%)	0.0%
Memory size	20.1 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	3
Q3	3
95-th percentile	4
Maximum	6
Range	5
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.8181772646
Coefficient of variation (CV)	0.2935894559
Kurtosis	0.3719131453
Mean	2.786807388
Median Absolute Deviation (MAD)	0
Skewness	0.00507977937
Sum	5281
Variance	0.6694140363
Monotocity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
3	983	38.4%
2	511	20.0%
4	257	10.0%
1	110	4.3%
5	32	1.2%
6	2	0.1%
(Missing)	666	26.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	110	4.3%
2	511	20.0%
3	983	38.4%
4	257	10.0%
5	32	1.2%

Value	Count	Frequency (%)
6	2	0.1%
5	32	1.2%
4	257	10.0%
3	983	38.4%
2	511	20.0%

ROOF_CONSTRUCTION
Categorical

Distinct	4
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	20.1 KiB

11.0	1891
nan	666
19.0	3
2.0	1

Length

Max length	4
Median length	4
Mean length	3.739554861
Min length	3

Characters and Unicode

Total characters	9577
Distinct characters	7
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	nan
2nd row	11.0
3rd row	11.0
4th row	11.0
5th row	11.0

Value	Count	Frequency (%)
11.0	1891	73.8%
nan	666	26.0%
19.0	3	0.1%
2.0	1	< 0.1%

Histogram of lengths of the category

Value	Count	Frequency (%)
11.0	1891	73.8%
nan	666	26.0%
19.0	3	0.1%
2.0	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
1	3785	39.5%
.	1895	19.8%
0	1895	19.8%
n	1332	13.9%
a	666	7.0%
9	3	< 0.1%
2	1	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	5684	59.4%
Lowercase Letter	1998	20.9%
Other Punctuation	1895	19.8%

Most frequent character per category

Value	Count	Frequency (%)
1	3785	66.6%
0	1895	33.3%
9	3	0.1%
2	1	< 0.1%

Value	Count	Frequency (%)
n	1332	66.7%
a	666	33.3%

Value	Count	Frequency (%)
.	1895	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	7579	79.1%
Latin	1998	20.9%

Most frequent character per script

Value	Count	Frequency (%)
1	3785	49.9%
.	1895	25.0%
0	1895	25.0%
9	3	< 0.1%
2	1	< 0.1%

Value	Count	Frequency (%)
n	1332	66.7%
a	666	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	9577	100.0%

Most frequent character per block

Value	Count	Frequency (%)
1	3785	39.5%
.	1895	19.8%
0	1895	19.8%
n	1332	13.9%
a	666	7.0%
9	3	< 0.1%
2	1	< 0.1%

WALL_CONSTRUCTION
Real number (ℝ_≥0)

MISSING
SKEWED

Distinct	6
Distinct (%)	0.3%
Missing	666
Missing (%)	26.0%
Infinite	0
Infinite (%)	0.0%

Mean	14.98944591
Minimum	3
Maximum	20
Zeros	0
Zeros (%)	0.0%
Memory size	20.1 KiB

Quantile statistics

Minimum	3
5-th percentile	15
Q1	15
median	15
Q3	15
95-th percentile	15
Maximum	20
Range	17
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.427282935
Coefficient of variation (CV)	0.0285055857
Kurtosis	671.8517803
Mean	14.98944591
Median Absolute Deviation (MAD)	0
Skewness	-22.50128421
Sum	28405
Variance	0.1825707066
Monotocity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
15	1889	73.8%
3	2	0.1%
20	1	< 0.1%
19	1	< 0.1%
11	1	< 0.1%
14	1	< 0.1%
(Missing)	666	26.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
3	2	0.1%
11	1	< 0.1%
14	1	< 0.1%
15	1889	73.8%
19	1	< 0.1%

Value	Count	Frequency (%)
20	1	< 0.1%
19	1	< 0.1%
15	1889	73.8%
14	1	< 0.1%
11	1	< 0.1%

FLOODING
Boolean

MISSING

Distinct	2
Distinct (%)	0.1%
Missing	666
Missing (%)	26.0%
Memory size	5.1 KiB

True	1851
False	44
(Missing)	666

Common Values
Chart

Value	Count	Frequency (%)
True	1851	72.3%
False	44	1.7%
(Missing)	666	26.0%

LISTED
Categorical

Distinct	5
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	20.1 KiB

3.0	1886
nan	666
2.0	7
1.0	1
5.0	1

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	7683
Distinct characters	8
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	0.1%

Sample

1st row	nan
2nd row	3.0
3rd row	3.0
4th row	3.0
5th row	3.0

Value	Count	Frequency (%)
3.0	1886	73.6%
nan	666	26.0%
2.0	7	0.3%
1.0	1	< 0.1%
5.0	1	< 0.1%

Histogram of lengths of the category

Value	Count	Frequency (%)
3.0	1886	73.6%
nan	666	26.0%
2.0	7	0.3%
1.0	1	< 0.1%
5.0	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
.	1895	24.7%
0	1895	24.7%
3	1886	24.5%
n	1332	17.3%
a	666	8.7%
2	7	0.1%
5	1	< 0.1%
1	1	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	3790	49.3%
Lowercase Letter	1998	26.0%
Other Punctuation	1895	24.7%

Most frequent character per category

Value	Count	Frequency (%)
0	1895	50.0%
3	1886	49.8%
2	7	0.2%
5	1	< 0.1%
1	1	< 0.1%

Value	Count	Frequency (%)
n	1332	66.7%
a	666	33.3%

Value	Count	Frequency (%)
.	1895	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	5685	74.0%
Latin	1998	26.0%

Most frequent character per script

Value	Count	Frequency (%)
.	1895	33.3%
0	1895	33.3%
3	1886	33.2%
2	7	0.1%
5	1	< 0.1%
1	1	< 0.1%

Value	Count	Frequency (%)
n	1332	66.7%
a	666	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	7683	100.0%

Most frequent character per block

Value	Count	Frequency (%)
.	1895	24.7%
0	1895	24.7%
3	1886	24.5%
n	1332	17.3%
a	666	8.7%
2	7	0.1%
5	1	< 0.1%
1	1	< 0.1%

MAX_DAYS_UNOCC
Categorical

Distinct	4
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	20.1 KiB

0.0	1402
nan	666
30.0	492
90.0	1

Length

Max length	4
Median length	3
Mean length	3.192502929
Min length	3

Characters and Unicode

Total characters	8176
Distinct characters	6
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	nan
2nd row	30.0
3rd row	30.0
4th row	0.0
5th row	0.0

Value	Count	Frequency (%)
0.0	1402	54.7%
nan	666	26.0%
30.0	492	19.2%
90.0	1	< 0.1%

Histogram of lengths of the category

Value	Count	Frequency (%)
0.0	1402	54.7%
nan	666	26.0%
30.0	492	19.2%
90.0	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	3790	46.4%
.	1895	23.2%
n	1332	16.3%
a	666	8.1%
3	492	6.0%
9	1	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	4283	52.4%
Lowercase Letter	1998	24.4%
Other Punctuation	1895	23.2%

Most frequent character per category

Value	Count	Frequency (%)
0	3790	88.5%
3	492	11.5%
9	1	< 0.1%

Value	Count	Frequency (%)
n	1332	66.7%
a	666	33.3%

Value	Count	Frequency (%)
.	1895	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	6178	75.6%
Latin	1998	24.4%

Most frequent character per script

Value	Count	Frequency (%)
0	3790	61.3%
.	1895	30.7%
3	492	8.0%
9	1	< 0.1%

Value	Count	Frequency (%)
n	1332	66.7%
a	666	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	8176	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	3790	46.4%
.	1895	23.2%
n	1332	16.3%
a	666	8.1%
3	492	6.0%
9	1	< 0.1%

NEIGH_WATCH
Boolean

MISSING

Distinct	2
Distinct (%)	0.1%
Missing	666
Missing (%)	26.0%
Memory size	5.1 KiB

False	1433
True	462
(Missing)	666

Common Values
Chart

Value	Count	Frequency (%)
False	1433	56.0%
True	462	18.0%
(Missing)	666	26.0%

OCC_STATUS
Categorical

MISSING

Distinct	3
Distinct (%)	0.2%
Missing	666
Missing (%)	26.0%
Memory size	20.1 KiB

PH	1886
LP	7
HH	2

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	3790
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	PH
2nd row	PH
3rd row	PH
4th row	PH
5th row	PH

Value	Count	Frequency (%)
PH	1886	73.6%
LP	7	0.3%
HH	2	0.1%
(Missing)	666	26.0%

Histogram of lengths of the category

Value	Count	Frequency (%)
ph	1886	99.5%
lp	7	0.4%
hh	2	0.1%

Most occurring characters

Value	Count	Frequency (%)
P	1893	49.9%
H	1890	49.9%
L	7	0.2%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	3790	100.0%

Most frequent character per category

Value	Count	Frequency (%)
P	1893	49.9%
H	1890	49.9%
L	7	0.2%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3790	100.0%

Most frequent character per script

Value	Count	Frequency (%)
P	1893	49.9%
H	1890	49.9%
L	7	0.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3790	100.0%

Most frequent character per block

Value	Count	Frequency (%)
P	1893	49.9%
H	1890	49.9%
L	7	0.2%

OWNERSHIP_TYPE
Real number (ℝ_≥0)

MISSING

Distinct	10
Distinct (%)	0.5%
Missing	666
Missing (%)	26.0%
Infinite	0
Infinite (%)	0.0%

Mean	7.600527704
Minimum	2
Maximum	18
Zeros	0
Zeros (%)	0.0%
Memory size	20.1 KiB

Quantile statistics

Minimum	2
5-th percentile	3
Q1	8
median	8
Q3	8
95-th percentile	12
Maximum	18
Range	16
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	2.467165528
Coefficient of variation (CV)	0.3246045043
Kurtosis	4.776959056
Mean	7.600527704
Median Absolute Deviation (MAD)	0
Skewness	0.6057756202
Sum	14403
Variance	6.08690574
Monotocity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
8	1507	58.8%
3	275	10.7%
12	48	1.9%
18	30	1.2%
14	24	0.9%
2	6	0.2%
11	2	0.1%
13	1	< 0.1%
16	1	< 0.1%
7	1	< 0.1%
(Missing)	666	26.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2	6	0.2%
3	275	10.7%
7	1	< 0.1%
8	1507	58.8%
11	2	0.1%

Value	Count	Frequency (%)
18	30	1.2%
16	1	< 0.1%
14	24	0.9%
13	1	< 0.1%
12	48	1.9%

PAYING_GUESTS
Categorical

Distinct	3
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	20.1 KiB

0.0	1894
nan	666
1.0	1

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	7683
Distinct characters	5
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	nan
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	0.0

Value	Count	Frequency (%)
0.0	1894	74.0%
nan	666	26.0%
1.0	1	< 0.1%

Histogram of lengths of the category

Value	Count	Frequency (%)
0.0	1894	74.0%
nan	666	26.0%
1.0	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	3789	49.3%
.	1895	24.7%
n	1332	17.3%
a	666	8.7%
1	1	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	3790	49.3%
Lowercase Letter	1998	26.0%
Other Punctuation	1895	24.7%

Most frequent character per category

Value	Count	Frequency (%)
n	1332	66.7%
a	666	33.3%

Value	Count	Frequency (%)
0	3789	> 99.9%
1	1	< 0.1%

Value	Count	Frequency (%)
.	1895	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	5685	74.0%
Latin	1998	26.0%

Most frequent character per script

Value	Count	Frequency (%)
0	3789	66.6%
.	1895	33.3%
1	1	< 0.1%

Value	Count	Frequency (%)
n	1332	66.7%
a	666	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	7683	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	3789	49.3%
.	1895	24.7%
n	1332	17.3%
a	666	8.7%
1	1	< 0.1%

PROP_TYPE
Real number (ℝ_≥0)

MISSING

Distinct	23
Distinct (%)	1.2%
Missing	666
Missing (%)	26.0%
Infinite	0
Infinite (%)	0.0%

Mean	10.02005277
Minimum	1
Maximum	53
Zeros	0
Zeros (%)	0.0%
Memory size	20.1 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	10
Q3	17
95-th percentile	25
Maximum	53
Range	52
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	9.092892602
Coefficient of variation (CV)	0.9074695324
Kurtosis	4.533075604
Mean	10.02005277
Median Absolute Deviation (MAD)	8
Skewness	1.687254796
Sum	18988
Variance	82.68069588
Monotocity	Not monotonic

Histogram with fixed size bins (bins=23)

Value	Count	Frequency (%)
10	538	21.0%
2	345	13.5%
1	318	12.4%
19	265	10.3%
9	151	5.9%
18	65	2.5%
25	64	2.5%
7	50	2.0%
26	29	1.1%
48	17	0.7%
Other values (13)	53	2.1%
(Missing)	666	26.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	318	12.4%
2	345	13.5%
3	1	< 0.1%
4	11	0.4%
7	50	2.0%

Value	Count	Frequency (%)
53	2	0.1%
52	1	< 0.1%
51	10	0.4%
48	17	0.7%
47	3	0.1%

SAFE_INSTALLED
Boolean

MISSING

Distinct	2
Distinct (%)	0.1%
Missing	666
Missing (%)	26.0%
Memory size	5.1 KiB

False	1879
True	16
(Missing)	666

Common Values
Chart

Value	Count	Frequency (%)
False	1879	73.4%
True	16	0.6%
(Missing)	666	26.0%

SEC_DISC_REQ
Boolean

MISSING

Distinct	2
Distinct (%)	0.1%
Missing	666
Missing (%)	26.0%
Memory size	5.1 KiB

True	1475
False	420
(Missing)	666

Common Values
Chart

Value	Count	Frequency (%)
True	1475	57.6%
False	420	16.4%
(Missing)	666	26.0%

SUBSIDENCE
Boolean

MISSING

Distinct	2
Distinct (%)	0.1%
Missing	666
Missing (%)	26.0%
Memory size	5.1 KiB

False	1879
True	16
(Missing)	666

Common Values
Chart

Value	Count	Frequency (%)
False	1879	73.4%
True	16	0.6%
(Missing)	666	26.0%

YEARBUILT
Real number (ℝ_≥0)

MISSING

Distinct	10
Distinct (%)	0.5%
Missing	666
Missing (%)	26.0%
Infinite	0
Infinite (%)	0.0%

Mean	1946.203694
Minimum	1749
Maximum	2000
Zeros	0
Zeros (%)	0.0%
Memory size	20.1 KiB

Quantile statistics

Minimum	1749
5-th percentile	1900
Q1	1920
median	1946
Q3	1960
95-th percentile	1990
Maximum	2000
Range	251
Interquartile range (IQR)	40

Descriptive statistics

Standard deviation	28.49086419
Coefficient of variation (CV)	0.01463919952
Kurtosis	1.23269023
Mean	1946.203694
Median Absolute Deviation (MAD)	14
Skewness	-0.6626701394
Sum	3688056
Variance	811.7293422
Monotocity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1946	666	26.0%
1960	314	12.3%
1920	309	12.1%
1980	298	11.6%
1900	144	5.6%
1990	65	2.5%
2000	41	1.6%
1869	29	1.1%
1870	28	1.1%
1749	1	< 0.1%
(Missing)	666	26.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1749	1	< 0.1%
1869	29	1.1%
1870	28	1.1%
1900	144	5.6%
1920	309	12.1%

Value	Count	Frequency (%)
2000	41	1.6%
1990	65	2.5%
1980	298	11.6%
1960	314	12.3%
1946	666	26.0%

CAMPAIGN_DESC
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	2561
Missing (%)	100.0%
Memory size	20.1 KiB

PAYMENT_METHOD
Categorical

MISSING

Distinct	3
Distinct (%)	0.2%
Missing	666
Missing (%)	26.0%
Memory size	20.1 KiB

NonDD	955
PureDD	872
DD-Other	68

Length

Max length	8
Median length	5
Mean length	5.567810026
Min length	5

Characters and Unicode

Total characters	10551
Distinct characters	12
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	NonDD
2nd row	PureDD
3rd row	NonDD
4th row	PureDD
5th row	NonDD

Value	Count	Frequency (%)
NonDD	955	37.3%
PureDD	872	34.0%
DD-Other	68	2.7%
(Missing)	666	26.0%

Histogram of lengths of the category

Value	Count	Frequency (%)
nondd	955	50.4%
puredd	872	46.0%
dd-other	68	3.6%

Most occurring characters

Value	Count	Frequency (%)
D	3790	35.9%
N	955	9.1%
o	955	9.1%
n	955	9.1%
r	940	8.9%
e	940	8.9%
P	872	8.3%
u	872	8.3%
-	68	0.6%
O	68	0.6%
Other values (2)	136	1.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	5685	53.9%
Lowercase Letter	4798	45.5%
Dash Punctuation	68	0.6%

Most frequent character per category

Value	Count	Frequency (%)
o	955	19.9%
n	955	19.9%
r	940	19.6%
e	940	19.6%
u	872	18.2%
t	68	1.4%
h	68	1.4%

Value	Count	Frequency (%)
D	3790	66.7%
N	955	16.8%
P	872	15.3%
O	68	1.2%

Value	Count	Frequency (%)
-	68	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	10483	99.4%
Common	68	0.6%

Most frequent character per script

Value	Count	Frequency (%)
D	3790	36.2%
N	955	9.1%
o	955	9.1%
n	955	9.1%
r	940	9.0%
e	940	9.0%
P	872	8.3%
u	872	8.3%
O	68	0.6%
t	68	0.6%

Value	Count	Frequency (%)
-	68	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	10551	100.0%

Most frequent character per block

Value	Count	Frequency (%)
D	3790	35.9%
N	955	9.1%
o	955	9.1%
n	955	9.1%
r	940	8.9%
e	940	8.9%
P	872	8.3%
u	872	8.3%
-	68	0.6%
O	68	0.6%
Other values (2)	136	1.3%

PAYMENT_FREQUENCY
Categorical

Distinct	2
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	20.1 KiB

nan	1733
1.0	828

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	7683
Distinct characters	5
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	nan
2nd row	nan
3rd row	nan
4th row	1.0
5th row	nan

Value	Count	Frequency (%)
nan	1733	67.7%
1.0	828	32.3%

Histogram of lengths of the category

Value	Count	Frequency (%)
nan	1733	67.7%
1.0	828	32.3%

Most occurring characters

Value	Count	Frequency (%)
n	3466	45.1%
a	1733	22.6%
1	828	10.8%
.	828	10.8%
0	828	10.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	5199	67.7%
Decimal Number	1656	21.6%
Other Punctuation	828	10.8%

Most frequent character per category

Value	Count	Frequency (%)
n	3466	66.7%
a	1733	33.3%

Value	Count	Frequency (%)
1	828	50.0%
0	828	50.0%

Value	Count	Frequency (%)
.	828	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	5199	67.7%
Common	2484	32.3%

Most frequent character per script

Value	Count	Frequency (%)
1	828	33.3%
.	828	33.3%
0	828	33.3%

Value	Count	Frequency (%)
n	3466	66.7%
a	1733	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	7683	100.0%

Most frequent character per block

Value	Count	Frequency (%)
n	3466	45.1%
a	1733	22.6%
1	828	10.8%
.	828	10.8%
0	828	10.8%

LEGAL_ADDON_PRE_REN
Boolean

MISSING

Distinct	2
Distinct (%)	0.1%
Missing	666
Missing (%)	26.0%
Memory size	5.1 KiB

True	1129
False	766
(Missing)	666

Common Values
Chart

Value	Count	Frequency (%)
True	1129	44.1%
False	766	29.9%
(Missing)	666	26.0%

LEGAL_ADDON_POST_REN
Boolean

MISSING

Distinct	2
Distinct (%)	0.1%
Missing	666
Missing (%)	26.0%
Memory size	5.1 KiB

True	1042
False	853
(Missing)	666

Common Values
Chart

Value	Count	Frequency (%)
True	1042	40.7%
False	853	33.3%
(Missing)	666	26.0%

HOME_EM_ADDON_PRE_REN
Boolean

MISSING

Distinct	2
Distinct (%)	0.1%
Missing	666
Missing (%)	26.0%
Memory size	5.1 KiB

False	1397
True	498
(Missing)	666

Common Values
Chart

Value	Count	Frequency (%)
False	1397	54.5%
True	498	19.4%
(Missing)	666	26.0%

HOME_EM_ADDON_POST_REN
Boolean

MISSING

Distinct	2
Distinct (%)	0.1%
Missing	666
Missing (%)	26.0%
Memory size	5.1 KiB

False	1819
True	76
(Missing)	666

Common Values
Chart

Value	Count	Frequency (%)
False	1819	71.0%
True	76	3.0%
(Missing)	666	26.0%

GARDEN_ADDON_PRE_REN
Boolean

MISSING

Distinct	2
Distinct (%)	0.1%
Missing	666
Missing (%)	26.0%
Memory size	5.1 KiB

False	1727
True	168
(Missing)	666

Common Values
Chart

Value	Count	Frequency (%)
False	1727	67.4%
True	168	6.6%
(Missing)	666	26.0%

GARDEN_ADDON_POST_REN
Boolean

MISSING

Distinct	2
Distinct (%)	0.1%
Missing	666
Missing (%)	26.0%
Memory size	5.1 KiB

False	1736
True	159
(Missing)	666

Common Values
Chart

Value	Count	Frequency (%)
False	1736	67.8%
True	159	6.2%
(Missing)	666	26.0%

KEYCARE_ADDON_PRE_REN
Boolean

MISSING

Distinct	2
Distinct (%)	0.1%
Missing	666
Missing (%)	26.0%
Memory size	5.1 KiB

False	1797
True	98
(Missing)	666

Common Values
Chart

Value	Count	Frequency (%)
False	1797	70.2%
True	98	3.8%
(Missing)	666	26.0%

KEYCARE_ADDON_POST_REN
Boolean

MISSING

Distinct	2
Distinct (%)	0.1%
Missing	666
Missing (%)	26.0%
Memory size	5.1 KiB

False	1787
True	108
(Missing)	666

Common Values
Chart

Value	Count	Frequency (%)
False	1787	69.8%
True	108	4.2%
(Missing)	666	26.0%

HP1_ADDON_PRE_REN
Boolean

CONSTANT
MISSING
REJECTED

Distinct	1
Distinct (%)	0.1%
Missing	666
Missing (%)	26.0%
Memory size	5.1 KiB

False	1895
(Missing)	666

Common Values
Chart

Value	Count	Frequency (%)
False	1895	74.0%
(Missing)	666	26.0%

HP1_ADDON_POST_REN
Boolean

MISSING

Distinct	2
Distinct (%)	0.1%
Missing	666
Missing (%)	26.0%
Memory size	5.1 KiB

False	1868
True	27
(Missing)	666

Common Values
Chart

Value	Count	Frequency (%)
False	1868	72.9%
True	27	1.1%
(Missing)	666	26.0%

HP2_ADDON_PRE_REN
Boolean

MISSING

Distinct	2
Distinct (%)	0.1%
Missing	666
Missing (%)	26.0%
Memory size	5.1 KiB

False	1893
True	2
(Missing)	666

Common Values
Chart

Value	Count	Frequency (%)
False	1893	73.9%
True	2	0.1%
(Missing)	666	26.0%

HP2_ADDON_POST_REN
Boolean

MISSING

Distinct	2
Distinct (%)	0.1%
Missing	666
Missing (%)	26.0%
Memory size	5.1 KiB

False	1558
True	337
(Missing)	666

Common Values
Chart

Value	Count	Frequency (%)
False	1558	60.8%
True	337	13.2%
(Missing)	666	26.0%

HP3_ADDON_PRE_REN
Boolean

MISSING

Distinct	2
Distinct (%)	0.1%
Missing	666
Missing (%)	26.0%
Memory size	5.1 KiB

False	1894
True	1
(Missing)	666

Common Values
Chart

Value	Count	Frequency (%)
False	1894	74.0%
True	1	< 0.1%
(Missing)	666	26.0%

HP3_ADDON_POST_REN
Boolean

MISSING

Distinct	2
Distinct (%)	0.1%
Missing	666
Missing (%)	26.0%
Memory size	5.1 KiB

False	1892
True	3
(Missing)	666

Common Values
Chart

Value	Count	Frequency (%)
False	1892	73.9%
True	3	0.1%
(Missing)	666	26.0%

MTA_FLAG
Boolean

MISSING

Distinct	2
Distinct (%)	0.1%
Missing	659
Missing (%)	25.7%
Memory size	5.1 KiB

False	1323
True	579
(Missing)	659

Common Values
Chart

Value	Count	Frequency (%)
False	1323	51.7%
True	579	22.6%
(Missing)	659	25.7%

MTA_FAP
Real number (ℝ)

HIGH CORRELATION
MISSING

Distinct	559
Distinct (%)	96.5%
Missing	1982
Missing (%)	77.4%
Infinite	0
Infinite (%)	0.0%

Mean	204.6248014
Minimum	-26.36
Maximum	1247.47
Zeros	0
Zeros (%)	0.0%
Memory size	20.1 KiB

Quantile statistics

Minimum	-26.36
5-th percentile	51.94
Q1	137.315
median	195.38
Q3	253.84
95-th percentile	380.791
Maximum	1247.47
Range	1273.83
Interquartile range (IQR)	116.525

Descriptive statistics

Standard deviation	111.2112037
Coefficient of variation (CV)	0.5434883894
Kurtosis	15.25507096
Mean	204.6248014
Median Absolute Deviation (MAD)	58.13
Skewness	2.322912032
Sum	118477.76
Variance	12367.93184
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
51.45	11	0.4%
51.94	5	0.2%
168.68	2	0.1%
198.01	2	0.1%
315.06	2	0.1%
54.75	2	0.1%
157.03	2	0.1%
215.55	2	0.1%
230.11	1	< 0.1%
318.03	1	< 0.1%
Other values (549)	549	21.4%
(Missing)	1982	77.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-26.36	1	< 0.1%
40.01	1	< 0.1%
41.16	1	< 0.1%
42.95	1	< 0.1%
43.88	1	< 0.1%

Value	Count	Frequency (%)
1247.47	1	< 0.1%
772.54	1	< 0.1%
705.61	1	< 0.1%
699.81	1	< 0.1%
601.48	1	< 0.1%

MTA_APRP
Real number (ℝ)

MISSING
ZEROS

Distinct	296
Distinct (%)	51.1%
Missing	1982
Missing (%)	77.4%
Infinite	0
Infinite (%)	0.0%

Mean	89.91554404
Minimum	-183.47
Maximum	1247.47
Zeros	274
Zeros (%)	10.7%
Memory size	20.1 KiB

Quantile statistics

Minimum	-183.47
5-th percentile	-0.279
Q1	0
median	0
Q3	180.425
95-th percentile	313.269
Maximum	1247.47
Range	1430.94
Interquartile range (IQR)	180.425

Descriptive statistics

Standard deviation	130.1781154
Coefficient of variation (CV)	1.447782103
Kurtosis	10.95599992
Mean	89.91554404
Median Absolute Deviation (MAD)	4.28
Skewness	2.134731291
Sum	52061.1
Variance	16946.34173
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	274	10.7%
51.45	6	0.2%
51.94	3	0.1%
215.55	2	0.1%
-0.36	2	0.1%
315.06	2	0.1%
271.79	1	< 0.1%
120.98	1	< 0.1%
212.18	1	< 0.1%
84.34	1	< 0.1%
Other values (286)	286	11.2%
(Missing)	1982	77.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-183.47	1	< 0.1%
-122.57	1	< 0.1%
-41.67	1	< 0.1%
-38.12	1	< 0.1%
-36.71	1	< 0.1%

Value	Count	Frequency (%)
1247.47	1	< 0.1%
705.61	1	< 0.1%
560.31	1	< 0.1%
555.43	1	< 0.1%
467.18	1	< 0.1%

MTA_DATE
Categorical

HIGH CARDINALITY
MISSING
UNIFORM

Distinct	205
Distinct (%)	79.2%
Missing	2302
Missing (%)	89.9%
Memory size	20.1 KiB

01/02/2010	4
09/01/2010	3
04/02/2010	3
11/01/2010	3
01/03/2010	3
Other values (200)	243

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	2590
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	161 ?
Unique (%)	62.2%

Sample

1st row	26/01/2010
2nd row	03/03/2010
3rd row	24/11/2009
4th row	08/11/2010
5th row	26/05/2010

Value	Count	Frequency (%)
01/02/2010	4	0.2%
09/01/2010	3	0.1%
04/02/2010	3	0.1%
11/01/2010	3	0.1%
01/03/2010	3	0.1%
23/11/2009	3	0.1%
10/02/2010	3	0.1%
20/01/2010	3	0.1%
20/02/2010	3	0.1%
22/04/2010	2	0.1%
Other values (195)	229	8.9%
(Missing)	2302	89.9%

Histogram of lengths of the category

Value	Count	Frequency (%)
01/02/2010	4	1.5%
11/01/2010	3	1.2%
20/02/2010	3	1.2%
23/11/2009	3	1.2%
20/01/2010	3	1.2%
04/02/2010	3	1.2%
09/01/2010	3	1.2%
10/02/2010	3	1.2%
01/03/2010	3	1.2%
02/03/2010	2	0.8%
Other values (195)	229	88.4%

Most occurring characters

Value	Count	Frequency (%)
0	809	31.2%
/	518	20.0%
1	461	17.8%
2	435	16.8%
9	106	4.1%
3	64	2.5%
8	48	1.9%
6	40	1.5%
7	37	1.4%
4	36	1.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2072	80.0%
Other Punctuation	518	20.0%

Most frequent character per category

Value	Count	Frequency (%)
0	809	39.0%
1	461	22.2%
2	435	21.0%
9	106	5.1%
3	64	3.1%
8	48	2.3%
6	40	1.9%
7	37	1.8%
4	36	1.7%
5	36	1.7%

Value	Count	Frequency (%)
/	518	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	2590	100.0%

Most frequent character per script

Value	Count	Frequency (%)
0	809	31.2%
/	518	20.0%
1	461	17.8%
2	435	16.8%
9	106	4.1%
3	64	2.5%
8	48	1.9%
6	40	1.5%
7	37	1.4%
4	36	1.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2590	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	809	31.2%
/	518	20.0%
1	461	17.8%
2	435	16.8%
9	106	4.1%
3	64	2.5%
8	48	1.9%
6	40	1.5%
7	37	1.4%
4	36	1.4%

LAST_ANN_PREM_GROSS
Real number (ℝ)

HIGH CORRELATION
MISSING

Distinct	1739
Distinct (%)	91.4%
Missing	659
Missing (%)	25.7%
Infinite	0
Infinite (%)	0.0%

Mean	188.3664826
Minimum	-26.36
Maximum	1247.47
Zeros	0
Zeros (%)	0.0%
Memory size	20.1 KiB

Quantile statistics

Minimum	-26.36
5-th percentile	51.94
Q1	124.815
median	179.735
Q3	237.7275
95-th percentile	361.1025
Maximum	1247.47
Range	1273.83
Interquartile range (IQR)	112.9125

Descriptive statistics

Standard deviation	99.9075918
Coefficient of variation (CV)	0.5303894323
Kurtosis	8.975209243
Mean	188.3664826
Median Absolute Deviation (MAD)	56.52
Skewness	1.635408979
Sum	358273.05
Variance	9981.5269
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
51.45	41	1.6%
51.94	28	1.1%
54.44	9	0.4%
52.63	6	0.2%
52.13	4	0.2%
54.75	4	0.2%
56.87	4	0.2%
55.51	3	0.1%
200	3	0.1%
53.69	3	0.1%
Other values (1729)	1797	70.2%
(Missing)	659	25.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-26.36	1	< 0.1%
40.01	1	< 0.1%
40.25	1	< 0.1%
41.16	2	0.1%
41.55	1	< 0.1%

Value	Count	Frequency (%)
1247.47	1	< 0.1%
772.54	1	< 0.1%
729.54	1	< 0.1%
729.3	1	< 0.1%
705.61	1	< 0.1%

POL_STATUS
Categorical

MISSING

Distinct	3
Distinct (%)	0.2%
Missing	666
Missing (%)	26.0%
Memory size	20.1 KiB

Live	1305
Lapsed	538
Cancelled	52

Length

Max length	9
Median length	4
Mean length	4.705013193
Min length	4

Characters and Unicode

Total characters	8916
Distinct characters	12
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Live
2nd row	Live
3rd row	Live
4th row	Lapsed
5th row	Live

Value	Count	Frequency (%)
Live	1305	51.0%
Lapsed	538	21.0%
Cancelled	52	2.0%
(Missing)	666	26.0%

Histogram of lengths of the category

Value	Count	Frequency (%)
live	1305	68.9%
lapsed	538	28.4%
cancelled	52	2.7%

Most occurring characters

Value	Count	Frequency (%)
e	1947	21.8%
L	1843	20.7%
i	1305	14.6%
v	1305	14.6%
a	590	6.6%
d	590	6.6%
p	538	6.0%
s	538	6.0%
l	104	1.2%
C	52	0.6%
Other values (2)	104	1.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	7021	78.7%
Uppercase Letter	1895	21.3%

Most frequent character per category

Value	Count	Frequency (%)
e	1947	27.7%
i	1305	18.6%
v	1305	18.6%
a	590	8.4%
d	590	8.4%
p	538	7.7%
s	538	7.7%
l	104	1.5%
n	52	0.7%
c	52	0.7%

Value	Count	Frequency (%)
L	1843	97.3%
C	52	2.7%

Most occurring scripts

Value	Count	Frequency (%)
Latin	8916	100.0%

Most frequent character per script

Value	Count	Frequency (%)
e	1947	21.8%
L	1843	20.7%
i	1305	14.6%
v	1305	14.6%
a	590	6.6%
d	590	6.6%
p	538	6.0%
s	538	6.0%
l	104	1.2%
C	52	0.6%
Other values (2)	104	1.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	8916	100.0%

Most frequent character per block

Value	Count	Frequency (%)
e	1947	21.8%
L	1843	20.7%
i	1305	14.6%
v	1305	14.6%
a	590	6.6%
d	590	6.6%
p	538	6.0%
s	538	6.0%
l	104	1.2%
C	52	0.6%
Other values (2)	104	1.2%

i
Real number (ℝ_≥0)

HIGH CORRELATION
UNIQUE

Distinct	2561
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	129830.3581
Minimum	33
Maximum	256113
Zeros	0
Zeros (%)	0.0%
Memory size	20.1 KiB

Quantile statistics

Minimum	33
5-th percentile	12463
Q1	66922
median	129826
Q3	194810
95-th percentile	243394
Maximum	256113
Range	256080
Interquartile range (IQR)	127888

Descriptive statistics

Standard deviation	74214.84674
Coefficient of variation (CV)	0.5716293774
Kurtosis	-1.19492662
Mean	129830.3581
Median Absolute Deviation (MAD)	63944
Skewness	-0.0282409952
Sum	332495547
Variance	5507843477
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
247809	1	< 0.1%
187721	1	< 0.1%
14938	1	< 0.1%
64192	1	< 0.1%
27330	1	< 0.1%
190426	1	< 0.1%
217797	1	< 0.1%
109254	1	< 0.1%
202630	1	< 0.1%
219848	1	< 0.1%
Other values (2551)	2551	99.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
33	1	< 0.1%
140	1	< 0.1%
200	1	< 0.1%
260	1	< 0.1%
281	1	< 0.1%

Value	Count	Frequency (%)
256113	1	< 0.1%
256092	1	< 0.1%
255984	1	< 0.1%
255962	1	< 0.1%
255892	1	< 0.1%

Police
Categorical

HIGH CARDINALITY
UNIFORM
UNIQUE

Distinct	2561
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	20.1 KiB

P043875	1
P110481	1
P022580	1
P207732	1
P094268	1
Other values (2556)	2556

Length

Max length	7
Median length	7
Mean length	7
Min length	7

Characters and Unicode

Total characters	17927
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2561 ?
Unique (%)	100.0%

Sample

1st row	P102224
2nd row	P058319
3rd row	P143989
4th row	P157076
5th row	P210969

Value	Count	Frequency (%)
P043875	1	< 0.1%
P110481	1	< 0.1%
P022580	1	< 0.1%
P207732	1	< 0.1%
P094268	1	< 0.1%
P036555	1	< 0.1%
P022334	1	< 0.1%
P104661	1	< 0.1%
P070198	1	< 0.1%
P254631	1	< 0.1%
Other values (2551)	2551	99.6%

Histogram of lengths of the category

Value	Count	Frequency (%)
p239899	1	< 0.1%
p051091	1	< 0.1%
p251129	1	< 0.1%
p181806	1	< 0.1%
p212781	1	< 0.1%
p013162	1	< 0.1%
p174339	1	< 0.1%
p073115	1	< 0.1%
p229489	1	< 0.1%
p160442	1	< 0.1%
Other values (2551)	2551	99.6%

Most occurring characters

Value	Count	Frequency (%)
P	2561	14.3%
1	2294	12.8%
0	2272	12.7%
2	1851	10.3%
3	1388	7.7%
4	1343	7.5%
5	1283	7.2%
8	1267	7.1%
9	1232	6.9%
7	1223	6.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	15366	85.7%
Uppercase Letter	2561	14.3%

Most frequent character per category

Value	Count	Frequency (%)
1	2294	14.9%
0	2272	14.8%
2	1851	12.0%
3	1388	9.0%
4	1343	8.7%
5	1283	8.3%
8	1267	8.2%
9	1232	8.0%
7	1223	8.0%
6	1213	7.9%

Value	Count	Frequency (%)
P	2561	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	15366	85.7%
Latin	2561	14.3%

Most frequent character per script

Value	Count	Frequency (%)
1	2294	14.9%
0	2272	14.8%
2	1851	12.0%
3	1388	9.0%
4	1343	8.7%
5	1283	8.3%
8	1267	8.2%
9	1232	8.0%
7	1223	8.0%
6	1213	7.9%

Value	Count	Frequency (%)
P	2561	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	17927	100.0%

Most frequent character per block

Value	Count	Frequency (%)
P	2561	14.3%
1	2294	12.8%
0	2272	12.7%
2	1851	10.3%
3	1388	7.7%
4	1343	7.5%
5	1283	7.2%
8	1267	7.1%
9	1232	6.9%
7	1223	6.8%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	df_index	QUOTE_DATE	COVER_START	CLAIM3YEARS	P1_EMP_STATUS	P1_PT_EMP_STATUS	BUS_USE	CLERICAL	AD_BUILDINGS	RISK_RATED_AREA_B	SUM_INSURED_BUILDINGS	NCD_GRANTED_YEARS_B	AD_CONTENTS	RISK_RATED_AREA_C	SUM_INSURED_CONTENTS	NCD_GRANTED_YEARS_C	CONTENTS_COVER	BUILDINGS_COVER	SPEC_SUM_INSURED	SPEC_ITEM_PREM	UNSPEC_HRP_PREM	P1_DOB	P1_MAR_STATUS	P1_POLICY_REFUSED	P1_SEX	APPR_ALARM	APPR_LOCKS	BEDROOMS	ROOF_CONSTRUCTION	WALL_CONSTRUCTION	FLOODING	LISTED	MAX_DAYS_UNOCC	NEIGH_WATCH	OCC_STATUS	OWNERSHIP_TYPE	PAYING_GUESTS	PROP_TYPE	SAFE_INSTALLED	SEC_DISC_REQ	SUBSIDENCE	YEARBUILT	CAMPAIGN_DESC	PAYMENT_METHOD	PAYMENT_FREQUENCY	LEGAL_ADDON_PRE_REN	LEGAL_ADDON_POST_REN	HOME_EM_ADDON_PRE_REN	HOME_EM_ADDON_POST_REN	GARDEN_ADDON_PRE_REN	GARDEN_ADDON_POST_REN	KEYCARE_ADDON_PRE_REN	KEYCARE_ADDON_POST_REN	HP1_ADDON_PRE_REN	HP1_ADDON_POST_REN	HP2_ADDON_PRE_REN	HP2_ADDON_POST_REN	HP3_ADDON_PRE_REN	HP3_ADDON_POST_REN	MTA_FLAG	MTA_FAP	MTA_APRP	MTA_DATE	LAST_ANN_PREM_GROSS	POL_STATUS	i	Police
0	102223	11/5/2011	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	102224	P102224
1	58318	1/6/2010	10/01/2010	N	R	NaN	N	NaN	Y	5.0	1000000.0	7.0	N	NaN	0.0	0.0	Y	N	0.0	0.00	0.00	29/10/1943	D	N	M	N	N	4.0	11.0	15.0	Y	3.0	30.0	N	PH	8.0	0.0	18.0	N	N	N	1960.0	NaN	NonDD	NaN	Y	Y	N	N	N	N	N	N	N	Y	N	N	N	N	N	NaN	NaN	NaN	132.91	Live	58319	P058319
2	143988	1/11/2011	15/01/2011	N	R	NaN	N	NaN	Y	11.0	1000000.0	6.0	Y	17.0	50000.0	6.0	Y	Y	0.0	0.00	0.00	06/07/1943	M	N	F	N	Y	3.0	11.0	15.0	Y	3.0	30.0	N	PH	8.0	0.0	10.0	N	Y	N	1920.0	NaN	PureDD	NaN	Y	Y	N	N	N	N	Y	Y	N	N	N	N	N	N	N	NaN	NaN	NaN	155.34	Live	143989	P143989
3	157075	NaN	09/11/1999	N	R	NaN	N	NaN	N	NaN	0.0	0.0	Y	2.0	50000.0	6.0	N	Y	0.0	0.00	0.00	03/05/1936	M	N	F	N	Y	2.0	11.0	15.0	Y	3.0	0.0	N	PH	8.0	0.0	19.0	N	Y	N	1946.0	NaN	NonDD	1.0	N	N	N	N	N	N	N	N	N	N	N	N	N	N	Y	42.95	0.00	NaN	42.95	Live	157076	P157076
4	210968	NaN	12/11/2009	N	E	NaN	N	NaN	Y	19.0	1000000.0	6.0	Y	17.0	50000.0	6.0	Y	Y	1235.0	9.83	0.00	16/02/1953	M	N	M	N	Y	3.0	11.0	15.0	Y	3.0	0.0	N	PH	3.0	0.0	10.0	N	Y	N	1946.0	NaN	PureDD	NaN	N	N	Y	Y	N	N	N	N	N	N	N	N	N	N	Y	252.33	0.00	NaN	252.33	Lapsed	210969	P210969
5	239720	NaN	22/12/2006	N	R	NaN	N	NaN	Y	8.0	1000000.0	6.0	Y	11.0	50000.0	6.0	Y	Y	0.0	0.00	0.00	06/06/1930	O	N	F	N	N	2.0	11.0	15.0	Y	3.0	0.0	N	PH	8.0	0.0	10.0	N	N	N	1946.0	NaN	NonDD	1.0	Y	Y	N	N	N	N	Y	Y	N	N	N	N	N	N	Y	153.11	153.11	26/01/2010	153.11	Live	239721	P239721
6	82917	NaN	21/02/2010	N	E	NaN	N	NaN	Y	8.0	1000000.0	7.0	Y	7.0	50000.0	7.0	Y	Y	0.0	0.00	16.67	22/04/1949	M	N	M	N	Y	3.0	11.0	15.0	Y	3.0	0.0	N	PH	8.0	0.0	1.0	N	Y	N	1960.0	NaN	PureDD	NaN	Y	Y	Y	N	Y	Y	N	N	N	N	N	Y	N	N	N	NaN	NaN	NaN	254.05	Live	82918	P082918
7	184331	1/20/2009	03/03/2009	N	R	NaN	N	NaN	Y	16.0	1000000.0	6.0	Y	37.0	50000.0	6.0	Y	Y	250.0	15.53	0.00	23/09/1934	S	N	F	N	N	3.0	11.0	15.0	Y	3.0	0.0	N	PH	8.0	0.0	51.0	N	N	N	1946.0	NaN	PureDD	NaN	Y	Y	Y	N	N	N	Y	Y	N	N	N	Y	N	N	Y	192.10	192.10	03/03/2010	192.10	Lapsed	184332	P184332
8	147226	NaN	07/02/2004	N	E	NaN	N	NaN	Y	NaN	1000000.0	6.0	N	NaN	0.0	0.0	Y	N	0.0	0.00	0.00	27/04/1950	O	N	F	N	Y	3.0	11.0	15.0	Y	3.0	0.0	N	PH	3.0	0.0	19.0	N	Y	N	1920.0	NaN	PureDD	1.0	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	NaN	NaN	NaN	168.50	Live	147227	P147227
9	203795	11/28/2007	28/11/2007	N	E	NaN	N	NaN	N	NaN	0.0	0.0	Y	18.0	50000.0	4.0	N	Y	0.0	0.00	0.00	20/11/1946	M	N	M	N	Y	2.0	11.0	15.0	Y	3.0	0.0	Y	PH	12.0	0.0	30.0	N	Y	N	1960.0	NaN	PureDD	NaN	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	NaN	NaN	NaN	129.87	Live	203796	P203796

Last rows

	df_index	QUOTE_DATE	COVER_START	CLAIM3YEARS	P1_EMP_STATUS	P1_PT_EMP_STATUS	BUS_USE	CLERICAL	AD_BUILDINGS	RISK_RATED_AREA_B	SUM_INSURED_BUILDINGS	NCD_GRANTED_YEARS_B	AD_CONTENTS	RISK_RATED_AREA_C	SUM_INSURED_CONTENTS	NCD_GRANTED_YEARS_C	CONTENTS_COVER	BUILDINGS_COVER	SPEC_SUM_INSURED	SPEC_ITEM_PREM	UNSPEC_HRP_PREM	P1_DOB	P1_MAR_STATUS	P1_POLICY_REFUSED	P1_SEX	APPR_ALARM	APPR_LOCKS	BEDROOMS	ROOF_CONSTRUCTION	WALL_CONSTRUCTION	FLOODING	LISTED	MAX_DAYS_UNOCC	NEIGH_WATCH	OCC_STATUS	OWNERSHIP_TYPE	PAYING_GUESTS	PROP_TYPE	SAFE_INSTALLED	SEC_DISC_REQ	SUBSIDENCE	YEARBUILT	CAMPAIGN_DESC	PAYMENT_METHOD	PAYMENT_FREQUENCY	LEGAL_ADDON_PRE_REN	LEGAL_ADDON_POST_REN	HOME_EM_ADDON_PRE_REN	HOME_EM_ADDON_POST_REN	GARDEN_ADDON_PRE_REN	GARDEN_ADDON_POST_REN	KEYCARE_ADDON_PRE_REN	KEYCARE_ADDON_POST_REN	HP1_ADDON_PRE_REN	HP1_ADDON_POST_REN	HP2_ADDON_PRE_REN	HP2_ADDON_POST_REN	HP3_ADDON_PRE_REN	HP3_ADDON_POST_REN	MTA_FLAG	MTA_FAP	MTA_APRP	MTA_DATE	LAST_ANN_PREM_GROSS	POL_STATUS	i	Police
2551	141526	NaN	04/03/2010	N	R	NaN	N	NaN	Y	14.0	1000000.0	6.0	Y	12.0	50000.0	6.0	Y	Y	0.0	0.0	0.00	24/12/1921	S	N	F	N	Y	3.0	11.0	15.0	Y	3.0	0.0	N	PH	8.0	0.0	18.0	N	Y	N	1920.0	NaN	NonDD	NaN	Y	Y	Y	N	N	N	N	N	N	N	N	Y	N	N	N	NaN	NaN	NaN	143.18	Live	141527	P141527
2552	182465	2/18/2012	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	182466	P182466
2553	227538	12/14/2011	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	227539	P227539
2554	183449	10/10/2008	20/11/2008	N	R	NaN	N	NaN	N	NaN	0.0	0.0	Y	3.0	50000.0	6.0	N	Y	0.0	0.0	16.07	26/05/1937	M	N	M	N	N	3.0	11.0	15.0	Y	3.0	0.0	N	PH	12.0	0.0	10.0	N	N	N	1946.0	NaN	NonDD	NaN	Y	Y	N	N	N	N	N	N	N	N	N	N	N	N	N	NaN	NaN	NaN	87.61	Lapsed	183450	P183450
2555	2883	11/4/2008	26/11/2008	N	R	NaN	N	NaN	Y	96.0	1000000.0	6.0	Y	8.0	50000.0	6.0	Y	Y	0.0	0.0	0.00	29/05/1923	M	N	F	Y	Y	1.0	11.0	15.0	Y	3.0	0.0	N	PH	8.0	0.0	48.0	N	Y	N	1946.0	NaN	PureDD	NaN	Y	Y	N	N	Y	Y	N	N	N	N	N	N	N	N	N	NaN	NaN	NaN	211.30	Live	2884	P002884
2556	32179	12/15/2010	15/12/2010	N	R	NaN	N	NaN	N	NaN	0.0	0.0	Y	6.0	50000.0	6.0	N	Y	0.0	0.0	0.00	13/10/1936	D	N	F	N	Y	3.0	11.0	15.0	Y	3.0	30.0	N	PH	14.0	0.0	9.0	N	Y	N	1980.0	NaN	NonDD	NaN	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	NaN	NaN	NaN	54.35	Lapsed	32180	P032180
2557	46887	1/7/2012	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	46888	P046888
2558	41574	12/1/2011	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	41575	P041575
2559	99410	11/26/2010	26/11/2010	N	R	NaN	N	NaN	Y	0.0	1000000.0	6.0	Y	0.0	50000.0	6.0	Y	Y	0.0	0.0	0.00	08/10/1939	M	N	M	N	Y	3.0	11.0	15.0	Y	3.0	30.0	N	PH	8.0	0.0	10.0	N	N	N	1960.0	NaN	NonDD	NaN	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	NaN	NaN	NaN	224.82	Lapsed	99411	P099411
2560	251158	12/18/2007	01/01/2011	N	R	NaN	N	NaN	Y	13.0	1000000.0	6.0	Y	15.0	50000.0	6.0	Y	Y	0.0	0.0	0.00	06/06/1935	M	N	M	N	Y	3.0	11.0	15.0	Y	3.0	0.0	N	PH	8.0	0.0	10.0	N	Y	N	1960.0	NaN	DD-Other	NaN	N	N	N	N	N	N	N	N	N	N	N	N	N	N	N	NaN	NaN	NaN	172.01	Cancelled	251159	P251159

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters